Create the Data Source for SERVICEDATASOURCE

  1. Select Edit Tree > Services> Data Sources.

  2. Click New.

    1. Name: This name can be anything, but has to be unique for the entire WebLogic server. If you have more than one OIPA instance on the server, then each instance should have a unique name.

    2. JNDI Name : SERVICELAYER. This name cannot be anything other than SERVICEDATASOURCE.

    3. Select Targets as server name Select (ServiceLayer) from available list and add to Chosen list

    4. Select the Data Source Type : Generic Data Source

    5. Database Type : Oracle

    6. Select the driver *Oracle Driver (Thin XA) for Service Connections; Version:Any.

    7. Enter the Database Name.

    8. Enter the Host Name of the database server.

    9. Enter the Port number of the database server.

    10. Enter the Database user name. This can be obtained from the database administrator who installed the databases.

    11. Enter both password entries. This can be obtained from the database administrator who installed the databases.

  3. Click on Create.
  4. Go to connection pool and click on TestConfiguration.
  5. Save and Commit the changes using Cart icon.

Note: Attached images are referring to SQL Server. For Oracle the User interface is similar.